gen inc_cat = .

**EXCESSIVE FORCE
replace inc_cat = 4 if allegation_category_code=="05A"
replace inc_cat = 4 if allegation_category_code=="05E"
replace inc_cat = 4 if allegation_category_code=="05M"
replace inc_cat = 4 if allegation_category_code=="05P"
replace inc_cat = 4 if allegation_category_code=="18A"
replace inc_cat = 4 if allegation_category_code=="19A"
replace inc_cat = 4 if allegation_category_code=="19B"
replace inc_cat = 4 if allegation_category_code=="19C"
replace inc_cat = 4 if allegation_category_code=="20B"
replace inc_cat = 4 if allegation_category_code=="20C"
replace inc_cat = 4 if allegation_category_code=="20D"

**OTHER PUBLIC MISCONDUCT
replace inc_cat = 3 if allegation_category_code=="01A"
replace inc_cat = 3 if allegation_category_code=="01B"
replace inc_cat = 3 if allegation_category_code=="01E"
replace inc_cat = 3 if allegation_category_code=="03A"
replace inc_cat = 3 if allegation_category_code=="03B"
replace inc_cat = 3 if allegation_category_code=="03C"
replace inc_cat = 3 if allegation_category_code=="03D"
replace inc_cat = 3 if allegation_category_code=="03G"
replace inc_cat = 3 if allegation_category_code=="03J"
replace inc_cat = 3 if allegation_category_code=="03K"
replace inc_cat = 3 if allegation_category_code=="03L"
replace inc_cat = 3 if allegation_category_code=="03N"
replace inc_cat = 3 if allegation_category_code=="03P"
replace inc_cat = 3 if allegation_category_code=="03Q"
replace inc_cat = 3 if allegation_category_code=="04C"
replace inc_cat = 3 if allegation_category_code=="04D"
replace inc_cat = 3 if allegation_category_code=="04E"
replace inc_cat = 3 if allegation_category_code=="04G"
replace inc_cat = 3 if allegation_category_code=="08K"
replace inc_cat = 3 if allegation_category_code=="09G"
replace inc_cat = 3 if allegation_category_code=="16A"
replace inc_cat = 3 if allegation_category_code=="16C"
replace inc_cat = 3 if allegation_category_code=="16E"

**OPERATIONAL VIOLATION
replace inc_cat = 2 if allegation_category_code=="02A"
replace inc_cat = 2 if allegation_category_code=="04A"
replace inc_cat = 2 if allegation_category_code=="04B"
replace inc_cat = 2 if allegation_category_code=="06A"
replace inc_cat = 2 if allegation_category_code=="06D"
replace inc_cat = 2 if allegation_category_code=="06G"
replace inc_cat = 2 if allegation_category_code=="06H"
replace inc_cat = 2 if allegation_category_code=="07B"
replace inc_cat = 2 if allegation_category_code=="08F"
replace inc_cat = 2 if allegation_category_code=="08H"
replace inc_cat = 2 if allegation_category_code=="08M"
replace inc_cat = 2 if allegation_category_code=="08Q"
replace inc_cat = 2 if allegation_category_code=="09A"
replace inc_cat = 2 if allegation_category_code=="09B"
replace inc_cat = 2 if allegation_category_code=="09C"
replace inc_cat = 2 if allegation_category_code=="09D"
replace inc_cat = 2 if allegation_category_code=="09F"
replace inc_cat = 2 if allegation_category_code=="09M"
replace inc_cat = 2 if allegation_category_code=="09R"
replace inc_cat = 2 if allegation_category_code=="10A"
replace inc_cat = 2 if allegation_category_code=="10AA"
replace inc_cat = 2 if allegation_category_code=="10B"
replace inc_cat = 2 if allegation_category_code=="10BB"
replace inc_cat = 2 if allegation_category_code=="10CC"
replace inc_cat = 2 if allegation_category_code=="10E"
replace inc_cat = 2 if allegation_category_code=="10F"
replace inc_cat = 2 if allegation_category_code=="10J"
replace inc_cat = 2 if allegation_category_code=="10L"
replace inc_cat = 2 if allegation_category_code=="10M"
replace inc_cat = 2 if allegation_category_code=="10P"
replace inc_cat = 2 if allegation_category_code=="10Q"
replace inc_cat = 2 if allegation_category_code=="10T"
replace inc_cat = 2 if allegation_category_code=="10U"
replace inc_cat = 2 if allegation_category_code=="10V"
replace inc_cat = 2 if allegation_category_code=="10W"
replace inc_cat = 2 if allegation_category_code=="12A"
replace inc_cat = 2 if allegation_category_code=="12B"
replace inc_cat = 2 if allegation_category_code=="12C"
replace inc_cat = 2 if allegation_category_code=="12D"
replace inc_cat = 2 if allegation_category_code=="12E"
replace inc_cat = 2 if allegation_category_code=="16B"
replace inc_cat = 2 if allegation_category_code=="16D"
replace inc_cat = 2 if allegation_category_code=="16F"

**OTHER
replace inc_cat = 1 if allegation_category_code=="04H"
replace inc_cat = 1 if allegation_category_code=="06K"
replace inc_cat = 1 if allegation_category_code=="07A"
replace inc_cat = 1 if allegation_category_code=="07C"
replace inc_cat = 1 if allegation_category_code=="07D"
replace inc_cat = 1 if allegation_category_code=="07E"
replace inc_cat = 1 if allegation_category_code=="07T"
replace inc_cat = 1 if allegation_category_code=="08C"
replace inc_cat = 1 if allegation_category_code=="08R"
replace inc_cat = 1 if allegation_category_code=="08S"
replace inc_cat = 1 if allegation_category_code=="20Z"
replace inc_cat = 1 if allegation_category_code=="21A"
replace inc_cat = 1 if allegation_category_code=="24A"
replace inc_cat = 1 if allegation_category_code=="24B"
